Devendrakumar Rajendran - A Blog to Oracle Financials World

-- FSG ROW SETS AND COLUMN SETS -- SELECT fst.id_flex_structure_name "COA" , decode(rw.axis_set_type,'R','ROW SET','C','COLUMN SET','##') "ROW/COLUMN" , rw.name"SET NAME" , rw.axis_set_id ,rw.creation_date FROM rg_report_axis_sets_v rw, fnd_id_flex_structures_v fst WHERE rw.structure_id = fst.id_flex_num AND substr(fst.id_flex_structure_name,1,2) in ('DC') ORDER BY 1,2,3; -- CONTENT SETS -- SELECT fst.id_flex_structure_name "COA" , cs.name , cs.content_set_id FROM rg_report_content_sets cs, fnd_id_flex_structures_v fst WHERE cs.structure_id = fst.id_flex_num AND substr(fst.id_flex_structure_name,1,2) in ('DC'); -- ROW ORDERS -- SELECT fst.id_flex_structure_name "COA" , ro.name "ROW ORDER" , ro.description "DESCRIPTION" , ro.structure_id , ro.row_order_id FROM rg_row_orders ro, fnd_id_flex_structures_v fst WHERE ro.structure_id = fst.id

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

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

Landed Cost - is a overall cost incur for a buyer to bring an item to his door. Example: I'm in India going to buy a soya pass from supplier who does business in United States. Lets take quantity im going to order is 2 metric tonnes. Item cost per metric ton is - 35,000 USD Total cost of an item = 35000 * 2 = 70,000 USD Total cost of an item which is a direct cost associated for an item and there would be other charges involved in bringing items through shipments like container fees, cargo handling fees, port clearances, marine insurances and so on., Summing up all together cost of importing an item will result in landed cost. From the landed cost we can get accurate cost for an item and which helps to determine unit selling price without any losses. In landed cost, salient features are. 1. Create shipments for items your purchase 2. Associate additional expenses incur for bringing those items to your godown 3. Do estimations 4. Do billings and find actual a