[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 *
1534: )
1535: IS
1536: SELECT a.mtl_cmpntcls_id,
1537: a.mtl_analysis_code, 1
1538: FROM cm_cmpt_mtl a
1539: WHERE (legal_entity_id = p_le_id OR legal_entity_id IS NULL)
1540: AND inventory_item_id = p_item_id
1541: AND (organization_id = p_orgn_id OR organization_id IS NULL)
1542: AND p_date BETWEEN eff_start_date AND eff_end_date
1542: AND p_date BETWEEN eff_start_date AND eff_end_date
1543: AND a.delete_mark = 0
1544: UNION
1545: SELECT b.mtl_cmpntcls_id, b.mtl_analysis_code, 2
1546: FROM cm_cmpt_mtl b
1547: WHERE (legal_entity_id = p_le_id OR legal_entity_id IS NULL)
1548: AND (organization_id = p_orgn_id OR organization_id IS NULL)
1549: AND p_date BETWEEN eff_start_date AND eff_end_date
1550: AND delete_mark = 0
4217: -- OPM inventory transaction should have the number we need already). There are
4218: -- pointers in the receiving transaction to the po_header, po_line and the receipt
4219: -- line too.
4220:
4221: -- The cost component class for the lot cost details is found in table cm_cmpt_mtl
4222: -- with a default from the fiscal policy if there isn't an entry in the table.
4223:
4224: -- Finally we have to keep in mind that a PORC transaction could be for a -ve quantity
4225: -- if goods are being returned to a vendor. In this respect, we shouldn't ever encounter