[Home] [Help]
84: --* *
85: --* 21-Jan-2004 umoogala Bug 3388974: Fixed burdens cursor to pickup burdens. *
86: --* Skip global burden for item when lot specific burden is there. *
87: --* *
88: --* 27-Jan-2004 PJS Bug 3388699: Amended cursor on cm_cmpt_mtl to retrieve analysis_code *
89: --* and cost component class successfully when using company as the sole *
90: --* criterion. Date ranging also added. *
91: --* *
92: --* 29-Jan-2004 PJS Reworked burdens processing and acquisition cost processing to ensure *
1228: )
1229: IS
1230: SELECT a.mtl_cmpntcls_id,
1231: a.mtl_analysis_code, 1
1232: FROM cm_cmpt_mtl a
1233: WHERE (legal_entity_id = p_le_id OR legal_entity_id IS NULL)
1234: AND inventory_item_id = p_item_id
1235: AND (organization_id = p_orgn_id OR organization_id IS NULL)
1236: AND p_date BETWEEN eff_start_date AND eff_end_date
1236: AND p_date BETWEEN eff_start_date AND eff_end_date
1237: AND a.delete_mark = 0
1238: UNION
1239: SELECT b.mtl_cmpntcls_id, b.mtl_analysis_code, 2
1240: FROM cm_cmpt_mtl b
1241: WHERE (legal_entity_id = p_le_id OR legal_entity_id IS NULL)
1242: AND (organization_id = p_orgn_id OR organization_id IS NULL)
1243: AND p_date BETWEEN eff_start_date AND eff_end_date
1244: AND delete_mark = 0
3503: -- OPM inventory transaction should have the number we need already). There are
3504: -- pointers in the receiving transaction to the po_header, po_line and the receipt
3505: -- line too.
3506:
3507: -- The cost component class for the lot cost details is found in table cm_cmpt_mtl
3508: -- with a default from the fiscal policy if there isn't an entry in the table.
3509:
3510: -- Finally we have to keep in mind that a PORC transaction could be for a -ve quantity
3511: -- if goods are being returned to a vendor. In this respect, we shouldn't ever encounter