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 140: UPDATE mtl_consumption_transactions

136:
137: IF (p_transaction_source_type_id=13) AND (p_transaction_action_id = 6)
138: AND (p_transaction_source_id IS NOT NULL)
139: THEN
140: UPDATE mtl_consumption_transactions
141: SET net_qty = (net_qty - ABS(p_transaction_quantity)),
142: secondary_net_qty = (secondary_net_qty - ABS(p_secondary_transaction_qty)), /* INVCONV */
143: consumption_processed_flag = Decode(Nvl(net_qty,0) - abs(p_transaction_quantity), 0, -- Bug 7361382 Changes Start
144: null, consumption_processed_flag) -- Bug 7361382 Changes End

Line 156: INSERT INTO mtl_consumption_transactions

152: l_secondary_net_qty := p_secondary_transaction_qty; /* INVCONV */
153: END IF;
154:
155:
156: INSERT INTO mtl_consumption_transactions
157: ( transaction_id
158: , consumption_processed_flag
159: , net_qty
160: , tax_code_id

Line 1113: , mtl_consumption_transactions mct

1109: , mct.blanket_price
1110: , SUM(mct.net_qty)
1111: FROM
1112: mtl_material_transactions mmt
1113: , mtl_consumption_transactions mct
1114: WHERE mmt.transaction_id = mct.transaction_id
1115: AND mct.consumption_processed_flag IN ('N','E')
1116: AND mmt.transaction_source_type_id = 1
1117: AND mmt.transaction_action_id = 6