APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on MTL_CONSUMPTION_TRANSACTIONS

Line 31: --| MTL_CONSUMPTION_TRANSACTIONS-Bug 4969421 |

27: --| Jul-29 rajkrish consigned error rpt |
28: --| 07-Mar-06 kdevadas BLANKET_PRICE and PO_DISTRIBUTION_ID |
29: --| columns added to MCT.PO price returned |
30: --| by get_break_price is inserted INTO |
31: --| MTL_CONSUMPTION_TRANSACTIONS-Bug 4969421 |
32: --| 22-May-06 kdevadas Delete from ZX_TRX_HEADERS_GT before |
33: --| insertion. This prevents 'Unique |
34: --| Constraint Violated' error- Bug 5084307 |
35: --| 18-Jul-06 kdevadas Get_Consumed_Amt procedure changed |

Line 138: UPDATE mtl_consumption_transactions

134:
135: IF (p_transaction_source_type_id=13) AND (p_transaction_action_id = 6)
136: AND (p_transaction_source_id IS NOT NULL)
137: THEN
138: UPDATE mtl_consumption_transactions
139: SET net_qty = (net_qty - ABS(p_transaction_quantity)),
140: secondary_net_qty = (secondary_net_qty - ABS(p_secondary_transaction_qty)) /* INVCONV */
141: WHERE transaction_id = p_transaction_source_id;
142:

Line 152: INSERT INTO mtl_consumption_transactions

148: l_secondary_net_qty := p_secondary_transaction_qty; /* INVCONV */
149: END IF;
150:
151:
152: INSERT INTO mtl_consumption_transactions
153: ( transaction_id
154: , consumption_processed_flag
155: , net_qty
156: , tax_code_id

Line 1105: , mtl_consumption_transactions mct

1101: , mct.blanket_price
1102: , SUM(mct.net_qty)
1103: FROM
1104: mtl_material_transactions mmt
1105: , mtl_consumption_transactions mct
1106: WHERE mmt.transaction_id = mct.transaction_id
1107: AND mct.consumption_processed_flag IN ('N','E')
1108: AND mmt.transaction_source_type_id = 1
1109: AND mmt.transaction_action_id = 6