Landed cost functional & technical references

How to get landed cost shipment details?

Inquire below tables to get LCM shipment details
inl_ship_headers_all - Get header details like item supplier name, shipment number, ship-to place
inl_ship_lines_all - Get item details, quantity, cost price, and organization going to receive

Can we add additional charge lines associated to an item?

Yes, we can add and estimate additional charge lines, third party details, and group references

What are all the additional cost factors associated to import an item in general?

a. Bill of lading fees
b. Container handling fees
c. Marine insurance
d. Onloading and offloading fees
e. Port clearance charges
f. Health inspection fees
g. Delivery order
h. Miscellaneous cost

How do charges lines are classified in the LCM application:
a. Shipment lines allocation
b. Charge lines allocation

Where do all charge lines get stored and what is a link to shipment table?

Charge lines are stored in INL_CHARGE_LINES table and to be connected with INL_ALLOCATIONS table to get "to_parent_table_name" column as a key to connect with shipment headers & lines table

How to get PO receipt number for LCM shipment?

In rcv_shipment_headers, if ASN type is LCM then those receipt shipment headers are created matching LCM shipment numbers.

Query reference:

select distinct rsh.receipt_num  into l_receipt_num from (select shipment_header_id, receipt_num, shipment_num,ship_to_org_id,asn_type from rcv_shipment_headers ) rsh,
 (select shipment_header_id, po_header_id, shipment_line_status_code,po_line_location_id from rcv_shipment_lines  ) rsl
where rsh.shipment_header_id = rsl.shipment_header_id
and rsl.po_header_id = p_po_header_id
and rsl.po_line_location_id = p_po_line_location_id
and rsh.shipment_num like p_lcm_ship_num||'%'
and rsh.asn_type = 'LCM'
and rsh.ship_to_org_id = p_org_id
and rsl.shipment_line_status_code <> 'CANCELLED';

 How to get billed amount for actual item line and additional charge lines?
In payable invoice lines if line type = 'ITEM' then get line amount as actual line item cost
if line type = 'MISC' then those lines are additional charge lines mapped against PO receipt

How to identify AP lines are billed against which additional charges?
Cost_factor_name is the key column in ap_invoice_lines table. Pass charge_line_type_id from LCM into cost_factor_id and get the cost factor name associated

Comments

Post a Comment

Popular posts from this blog

How to use lexical parameters in Data template (XML document) R12

Lexical parameters can be added in data definition using &variable name This is flexible variable string where you can execute runtime conditions based on user-inputs Example 1. Append &gc_journal_filter at the end of sql statement 2. Define beforereport function in package signature FUNCTION beforereport RETURN BOOLEAN; 3. Define all the report parameters as a package variable in package signature including lexical parameters 4. Implement beforereport function by building your runtime conditions to be added to SQL statements  FUNCTION beforereport RETURN BOOLEAN IS  BEGIN          IF p_journal_source IS NULL THEN       gc_journal_filter := ' AND jh.je_source IN (''AutoCopy'',''Manual'')';     END IF;          IF p_journal_category IS NULL THEN       gc_journal_filter := 'AND jh.je_category IN (''Other'') ';     END IF;    RETURN TRUE;  END;
Read more

Query to get FSG report details with row/column set

Below query is to fetch FSG report titles, names, and description along with will give a view to list of row sets and column sets associated with the report. -- FSG REPORTS -- SELECT fst.id_flex_structure_name , R.NAME , R.report_title , R.DESCRIPTION , R.column_set "COLUMN SET" , rw2.structure_id , rw2.DESCRIPTION "COL DESC" , R.row_set "ROW SET" , rw.DESCRIPTION "ROW DESC" , R.report_display_set "DISPLAY SET" , R.content_set "CONTENT SET" , R.row_order "ROW ORDER" , R.rounding_option "RND" , u.user_name , u.DESCRIPTION , R.creation_date FROM rg_reports_v R    , fnd_id_flex_structures_v fst    , fnd_user u    , rg_report_axis_sets_v rw    , rg_report_axis_sets_v rw2 WHERE r.structure_id = fst.id_flex_num AND R.row_set_id     = rw.axis_set_id AND r.column_set_id  = rw2.axis_set_id AND SUBSTR(fst.id_flex_structure_name,1,2) IN ('DC') AND R.created_by     = u.user_id OR
Read more

Sub Inventory Transfer API.

Image
Sub Inventory transfer is used to move materials from one sub-inventory to another within same organization. This is especially used to 1. Adjust on-hand quantities between sub-inventories 2. Transfer to another sub-inventories for specific business need like additional sales 3. Damages/expiry products can be moved to non-asset sub-inventories to discard it from inventory valuation report and so on., Key elements 1. From sub inventory 2. To sub inventory 3. Organization 4. Inventory item 5. Transact quantity 6. Transact unit of measure 7. Transaction type 8. Transaction action 9. Transact Reference 10. Transact date 11. Lot Number Open Interfaces mtl_transactions_interface - is used to populate sub inventory transfer details mtl_transaction_lots_interface - is used to populate lot details for particular sub inventory transfer Base Tables mtl_material_transactions - is used to get all type of material transactions like sub-inventory transfer, inter-org tra
Read more