eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on MTL_CONSUMPTION_TRANSACTIONS

Line 98: -- COMMENT : Update mtl_consumption_transactions table with the

94: /* Bug 4969421 Starts here*/
95: --========================================================================
96: -- PROCEDURE : Update_PO_Distrubution_Id PRIVATE
97: -- PARAMETERS : -
98: -- COMMENT : Update mtl_consumption_transactions table with the
99: -- po_distribution_id and the blanket_price for all the
100: -- processed transactions
101: --========================================================================
102: PROCEDURE update_po_distrubution_id

Line 122: MTL_CONSUMPTION_TRANSACTIONS mct

118: /* Bug 5373370 - Start */
119: , mct.interface_distribution_ref
120: /* Bug 5373370 - End */
121: FROM
122: MTL_CONSUMPTION_TRANSACTIONS mct
123: WHERE
124: ( mct.blanket_price IS NULL OR mct.po_distribution_id IS NULL )
125: AND mct.net_qty > 0
126: AND mct.request_id = g_request_id

Line 182: MTL_CONSUMPTION_TRANSACTIONS mct,

178: -- Bug 5092489, Query modified to avoid use of MMT
179: SELECT pod.po_distribution_id
180: INTO l_po_distribution_id
181: FROM
182: MTL_CONSUMPTION_TRANSACTIONS mct,
183: --MTL_MATERIAL_TRANSACTIONS mmt,
184: po_line_locations_all poll,
185: po_distributions_all pod,
186: po_lines_all pol

Line 225: MTL_CONSUMPTION_TRANSACTIONS mct,

221: -- Bug 5092489, Query modified to avoid use of MMT
222: SELECT pod.po_distribution_id
223: INTO l_po_distribution_id
224: FROM
225: MTL_CONSUMPTION_TRANSACTIONS mct,
226: --MTL_MATERIAL_TRANSACTIONS mmt,
227: po_line_locations_all poll,
228: po_distributions_all pod,
229: po_lines_all pol

Line 265: ( 'Updating MTL_CONSUMPTION_TRANSACTIONS with po_distrubution_id '

261:
262: IF (l_debug = 1)
263: THEN
264: INV_LOG_UTIL.trace
265: ( 'Updating MTL_CONSUMPTION_TRANSACTIONS with po_distrubution_id '
266: ||l_po_distribution_id
267: , 9
268: );
269: END IF;

Line 271: UPDATE MTL_CONSUMPTION_TRANSACTIONS

267: , 9
268: );
269: END IF;
270:
271: UPDATE MTL_CONSUMPTION_TRANSACTIONS
272: SET po_distribution_id = l_po_distribution_id
273: WHERE transaction_id = l_transaction_id ;
274:
275: COMMIT;

Line 333: -- COMMENT : Update mtl_consumption_transactions table

329: -- p_accrual_account_id Accrual account
330: -- p_variance_account_id Variance account
331: -- p_charg_account_id Charge account
332: -- p_transaction_date Date of transaction
333: -- COMMENT : Update mtl_consumption_transactions table
334: -- This procedure is called by the Create_Consumption_Advice
335: -- procedures after creation of the
336: -- document. Update the table with the appropriate release
337: -- info or the po_header info.

Line 484: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct

480:
481: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
482: THEN
483: -- Bug 5092489, Query modified to eliminate use of MMT in subquery
484: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct
485: SET mct.consumption_po_header_id = p_consumption_po_header_id
486: , mct.consumption_release_id = p_consumption_release_id
487: , mct.consumption_processed_flag = l_consumption_processed_flag
488: , mct.error_code = p_error_code

Line 506: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct

502:
503: -- Deleted unused commented code as part of bug 11900144
504: ELSE
505: -- Bug 5092489, Query modified to eliminate use of MMT in subquery
506: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct
507: SET mct.consumption_po_header_id = p_consumption_po_header_id
508: , mct.consumption_release_id = p_consumption_release_id
509: , mct.consumption_processed_flag = l_consumption_processed_flag
510: , mct.error_code = p_error_code

Line 538: UPDATE MTL_CONSUMPTION_TRANSACTIONS

534: WHERE transaction_source_id = p_transaction_source_id));
535: */
536: END IF;
537:
538: UPDATE MTL_CONSUMPTION_TRANSACTIONS
539: SET consumption_po_header_id = p_consumption_po_header_id
540: , consumption_release_id = p_consumption_release_id
541: , consumption_processed_flag = l_consumption_processed_flag
542: , error_code = p_error_code

Line 546: FROM MTL_CONSUMPTION_TRANSACTIONS mct

542: , error_code = p_error_code
543: , error_explanation = l_error_explanation
544: WHERE parent_transaction_id IN
545: (SELECT mct.transaction_id
546: FROM MTL_CONSUMPTION_TRANSACTIONS mct
547: WHERE mct.batch_id = p_batch_id
548: AND mct.charge_account_id = p_charge_account_id
549: AND mct.variance_account_id = p_variance_account_id
550: AND NVL(mct.rate_type,'##') = NVL(p_global_rate_type,'##')

Line 572: -- from MTL_CONSUMPTION_TRANSACTIONS to

568:
569: --========================================================================
570: -- PROCEDURE : Load_Combination PRIVATE
571: -- COMMENT : This procedure will load all the records of a context batch
572: -- from MTL_CONSUMPTION_TRANSACTIONS to
573: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP
574: -- If the batch_id passed is -1 then the call is from the
575: -- manager in which case all records with a
576: -- processed_consumption_flag are loaded.

Line 573: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP

569: --========================================================================
570: -- PROCEDURE : Load_Combination PRIVATE
571: -- COMMENT : This procedure will load all the records of a context batch
572: -- from MTL_CONSUMPTION_TRANSACTIONS to
573: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP
574: -- If the batch_id passed is -1 then the call is from the
575: -- manager in which case all records with a
576: -- processed_consumption_flag are loaded.
577: -- The insert statement will also be selective by the

Line 656: MTL_CONSUMPTION_TRANSACTIONS mct

652: , SUM(mct.net_qty)
653: /* Bug 11900144. Addition of po_line_id */
654: , mct.po_line_id
655: FROM
656: MTL_CONSUMPTION_TRANSACTIONS mct
657: , po_vendor_sites_all pvsa
658: WHERE mct.owning_organization_id = pvsa.vendor_site_id
659: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
660: AND mct.owning_organization_id =

Line 725: -- from MTL_CONSUMPTION_TRANSACTIONS to

721:
722: --========================================================================
723: -- PROCEDURE : Load_Combination_prf PRIVATE
724: -- COMMENT : This procedure will load all the records of a context batch
725: -- from MTL_CONSUMPTION_TRANSACTIONS to
726: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP
727: -- If the batch_id passed is -1 then the call is from the
728: -- manager in which case all records with a
729: -- processed_consumption_flag are loaded.

Line 726: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP

722: --========================================================================
723: -- PROCEDURE : Load_Combination_prf PRIVATE
724: -- COMMENT : This procedure will load all the records of a context batch
725: -- from MTL_CONSUMPTION_TRANSACTIONS to
726: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP
727: -- If the batch_id passed is -1 then the call is from the
728: -- manager in which case all records with a
729: -- processed_consumption_flag are loaded.
730: -- The insert statement will also be selective by the

Line 806: MTL_CONSUMPTION_TRANSACTIONS mct

802: , SUM(mct.net_qty)
803: /* Bug 11900144. Addition of po_line_id */
804: , mct.po_line_id
805: FROM
806: MTL_CONSUMPTION_TRANSACTIONS mct
807: , po_vendor_sites_all pvsa
808: WHERE mct.owning_organization_id = pvsa.vendor_site_id
809: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
810: AND mct.owning_organization_id =

Line 888: MTL_CONSUMPTION_TRANSACTIONS mct

884: , SUM(mct.net_qty)
885: /* Bug 11900144. Addition of po_line_id */
886: , mct.po_line_id
887: FROM
888: MTL_CONSUMPTION_TRANSACTIONS mct
889: , po_vendor_sites_all pvsa
890: WHERE mct.owning_organization_id = pvsa.vendor_site_id
891: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
892: AND mct.owning_organization_id =

Line 928: MTL_CONSUMPTION_TRANSACTIONS mct

924: (SELECT
925: TRUNC(MAX(mct.transaction_date))
926: FROM
927: --MTL_MATERIAL_TRANSACTIONS mmt
928: MTL_CONSUMPTION_TRANSACTIONS mct
929: WHERE --mct.transaction_id = mmt.transaction_id AND
930: mct.transaction_source_id = mctt.transaction_source_id
931: AND mct.inventory_item_id = mctt.inventory_item_id
932: AND mct.organization_id = mctt.organization_id

Line 1114: UPDATE mtl_consumption_transactions SET

1110: /* bug 5113064 - Start */
1111: /* delete all records in MCT_TEMP that have valid flag as 'N' */
1112: /* Also update MCT records with error status and message */
1113: /*Bug 5092489. Query is modified to eliminate use of MMT. */
1114: UPDATE mtl_consumption_transactions SET
1115: consumption_processed_flag = 'E'
1116: , error_code = l_error_msg
1117: WHERE transaction_source_id = l_header_id
1118: AND inventory_item_id = l_item_id

Line 2126: UPDATE mtl_consumption_transactions

2122: PO_DISTRIBUTION_ID */
2123:
2124: /* MMT no longer used in this query */
2125:
2126: UPDATE mtl_consumption_transactions
2127: SET interface_distribution_ref = TO_CHAR(l_dist_interface_header_id)
2128: WHERE transaction_id IN
2129: ( SELECT mct.transaction_id
2130: FROM MTL_CONSUMPTION_TRANSACTIONS mct

Line 2130: FROM MTL_CONSUMPTION_TRANSACTIONS mct

2126: UPDATE mtl_consumption_transactions
2127: SET interface_distribution_ref = TO_CHAR(l_dist_interface_header_id)
2128: WHERE transaction_id IN
2129: ( SELECT mct.transaction_id
2130: FROM MTL_CONSUMPTION_TRANSACTIONS mct
2131: WHERE mct.consumption_processed_flag IN ('N','E')
2132: AND mct.inventory_item_id = l_item_id
2133: AND mct.transaction_source_id = l_blanket_id
2134: AND mct.blanket_price = l_blanket_price

Line 2463: -- MTL_CONSUMPTION_TRANSACTIONS for a unique combination of

2459:
2460: --========================================================================
2461: -- PROCEDURE : Load_Summarized_Quantity PRIVATE
2462: -- COMMENT : This procedure summarizes records in
2463: -- MTL_CONSUMPTION_TRANSACTIONS for a unique combination of
2464: -- transaction_source_id, inventory_item_id, organization_id
2465: -- transaction cost, tax code id, accrual account, variance
2466: -- account, charge account
2467: -- present in MTL_CONSUMPTION_TXN_TEMP. The result updates the

Line 2557: FROM MTL_CONSUMPTION_TRANSACTIONS mct

2553: UPDATE/*+ leading(mctt) */ MTL_CONSUMPTION_TXN_TEMP mctt
2554: SET (mctt.net_qty,mctt.secondary_net_qty) =
2555: (SELECT SUM(mct.net_qty),SUM(mct.secondary_net_qty)
2556:
2557: FROM MTL_CONSUMPTION_TRANSACTIONS mct
2558: --, MTL_MATERIAL_TRANSACTIONS mmt
2559: WHERE --mmt.transaction_id = mct.transaction_id AND
2560: mct.transaction_source_id = p_txn_source_tab(i)
2561: AND mct.inventory_item_id = p_inventory_item_tab(i)

Line 2640: -- MTL_CONSUMPTION_TRANSACTIONS for a unique combination of

2636:
2637: --========================================================================
2638: -- PROCEDURE : Load_Summarized_Quantity_prf PRIVATE
2639: -- COMMENT : This procedure summarizes records in
2640: -- MTL_CONSUMPTION_TRANSACTIONS for a unique combination of
2641: -- transaction_source_id, inventory_item_id, organization_id
2642: -- transaction cost, tax code id, accrual account, variance
2643: -- account, charge account
2644: -- present in MTL_CONSUMPTION_TXN_TEMP. The result updates the

Line 2733: FROM MTL_CONSUMPTION_TRANSACTIONS mct

2729: UPDATE/*+ leading(mctt) */ MTL_CONSUMPTION_TXN_TEMP mctt
2730: SET (mctt.net_qty,mctt.secondary_net_qty) =
2731: (SELECT SUM(mct.net_qty),SUM(mct.secondary_net_qty)
2732:
2733: FROM MTL_CONSUMPTION_TRANSACTIONS mct
2734: --, MTL_MATERIAL_TRANSACTIONS mmt
2735: WHERE --mmt.transaction_id = mct.transaction_id AND
2736: mct.transaction_source_id = p_txn_source_tab(i)
2737: AND mct.inventory_item_id = p_inventory_item_tab(i)

Line 2784: FROM MTL_CONSUMPTION_TRANSACTIONS mct

2780: FORALL i IN p_txn_source_tab.FIRST..p_txn_source_tab.LAST
2781: UPDATE/*+ leading(mctt) */ MTL_CONSUMPTION_TXN_TEMP mctt
2782: SET mctt.net_qty =
2783: (SELECT SUM(mct.net_qty)
2784: FROM MTL_CONSUMPTION_TRANSACTIONS mct
2785: --, MTL_MATERIAL_TRANSACTIONS mmt
2786: WHERE --mmt.transaction_id = mct.transaction_id AND
2787: mct.transaction_source_id = p_txn_source_tab(i)
2788: AND mct.inventory_item_id = p_inventory_item_tab(i)

Line 2862: -- : MTL_CONSUMPTION_TRANSACTIONS should not be

2858: -- PROCEDURE : Delete Record PRIVATE
2859: -- COMMENT : If the billing date for the current asl entry
2860: -- : has not elapsed yet then the associated
2861: -- : change of ownership transactions held in
2862: -- : MTL_CONSUMPTION_TRANSACTIONS should not be
2863: -- : processed yet. The current record slipped
2864: -- : into this loop for that reason and should
2865: -- : therefore be deleted from the current batch
2866:

Line 2913: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct

2909: AND mctt.rate = p_rate
2910: AND mctt.rate_type = p_rate_type;
2911:
2912: -- Bug 5092489. Query modified for better performance
2913: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct
2914: SET mct.batch_id = NULL
2915: WHERE mct.transaction_source_id = p_txn_source_id
2916: AND mct.inventory_item_id = p_inventory_item_id
2917: AND mct.organization_id = p_organization_id

Line 3073: FROM MTL_CONSUMPTION_TRANSACTIONS mct

3069:
3070: CURSOR con_ad_err_cur IS
3071: SELECT mct.transaction_id
3072: , mct.error_code
3073: FROM MTL_CONSUMPTION_TRANSACTIONS mct
3074: WHERE mct.consumption_processed_flag = 'E'
3075: AND mct.batch_id = p_batch_id;
3076:
3077: --=================

Line 3166: FROM MTL_CONSUMPTION_TRANSACTIONS mct ,

3162: mmt.REVISION ,
3163: mmt.OWNING_ORGANIZATION_ID ,
3164: mmt.ORGANIZATION_ID ,
3165: mmt.TRANSACTION_DATE
3166: FROM MTL_CONSUMPTION_TRANSACTIONS mct ,
3167: MTL_MATERIAL_TRANSACTIONS mmt
3168: WHERE mmt.transaction_id = mct.transaction_id
3169: AND consumption_processed_flag IN ( 'N',
3170: 'E')

Line 3251: UPDATE mtl_consumption_transactions mct

3247: END;
3248: END IF;
3249: -- End of bug 9539634
3250: /* update the po line id and make it ready to be processed */
3251: UPDATE mtl_consumption_transactions mct
3252: SET batch_id = NULL,
3253: po_line_id =l_document_line_id
3254: WHERE consumption_processed_flag in ('N','E')
3255: AND transaction_id = l_transaction_id(i)

Line 3273: -- from MTL_CONSUMPTION_TRANSACTIONS to

3269:
3270: --========================================================================
3271: -- PROCEDURE : Consumption_Txn_Worker PRIVATE
3272: -- COMMENT : This procedure will copy all the records of a context batch
3273: -- from MTL_CONSUMPTION_TRANSACTIONS to
3274: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP
3275: -- summarize the net quantity and call the create consumption
3276: -- advice procedure
3277: --=========================================================================

Line 3274: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP

3270: --========================================================================
3271: -- PROCEDURE : Consumption_Txn_Worker PRIVATE
3272: -- COMMENT : This procedure will copy all the records of a context batch
3273: -- from MTL_CONSUMPTION_TRANSACTIONS to
3274: -- MTL_CONSUMPTION_TRANSACTIONS_TEMP
3275: -- summarize the net quantity and call the create consumption
3276: -- advice procedure
3277: --=========================================================================
3278: PROCEDURE consumption_txn_worker

Line 3371: -- from MTL_CONSUMPTION_TRANSACTIONS

3367: );
3368: END IF;
3369:
3370: -- Call procedure to load MTL_CONSUMPTION_TXNS_TEMP
3371: -- from MTL_CONSUMPTION_TRANSACTIONS
3372: -- with records that belong to the specified batch
3373:
3374: IF NVL(FND_PROFILE.value('INV_SUPPLIER_CONSIGNED_GROUPING'),'N') = 'N'
3375: THEN

Line 3448: -- MTL_CONSUMPTION_TRANSACTIONS associated with

3444: EXIT WHEN l_bulk_count = cons_temp_csr_type%ROWCOUNT;
3445: /* Bug 5006151 - End */
3446:
3447: -- Summarize the net quantity of all records in
3448: -- MTL_CONSUMPTION_TRANSACTIONS associated with
3449: -- records in MTL_CONSUMPTION_TXNS_TEMP.
3450: -- Record the result in MTL_CONSUMPTION_TXNS_TEMP.
3451:
3452: /* BUg 5092489. Following IF block is commented becasue quantity is populated during insert

Line 3678: UPDATE mtl_consumption_transactions

3674: ,x_return_status => l_return_status);
3675: /* Bug 4599072 - Start */
3676: /* bug 5113064 - Start */
3677: /* clean up invalid records in MCT */
3678: UPDATE mtl_consumption_transactions
3679: SET batch_id = NULL
3680: WHERE batch_id = p_batch_id
3681: AND consumption_processed_flag IN ('N','E')
3682: AND consumption_po_header_id IS NULL

Line 3708: -- the records in MTL_CONSUMPTION_TRANSACTIONS

3704: -- FUNCTION : Generate_Batch_Id PRIVATE
3705: -- PARAMETERS: None
3706: -- RETURNS : NUMBER
3707: -- COMMENT : This function returns the next batch id to be assigned to
3708: -- the records in MTL_CONSUMPTION_TRANSACTIONS
3709: --=========================================================================
3710: FUNCTION generate_batch_id
3711: RETURN NUMBER
3712: IS

Line 3989: -- associated records in MTL_CONSUMPTION_TRANSACTIONS are

3985: -- PROCEDURE : Batch Allocation PRIVATE
3986: -- COMMENT : This procedure will be called exclusively from the manager.
3987: -- It divides candidate unprocessed records into batches.
3988: -- Once the contents of a batch are established the
3989: -- associated records in MTL_CONSUMPTION_TRANSACTIONS are
3990: -- updated with a batch id and a concurrent program submitted.
3991: -- If there are more candidate unprocessed records then further
3992: -- batches are established and concurrent programs submitted.
3993: -- Thus for large numbers of records concurrency can be achieved.

Line 4162: -- Allocate a batch id to records in MTL_CONSUMPTION_TRANSACTIONS

4158: END LOOP;
4159:
4160: CLOSE cons_temp_csr_type;
4161:
4162: -- Allocate a batch id to records in MTL_CONSUMPTION_TRANSACTIONS
4163: -- A new batch is started if the current batch is full or if the
4164: -- number of summarized records in the next batch exceeds
4165: -- the size remaining in the current batch. The only exception to
4166: -- this rule is when the first record a new batch is being

Line 4302: MTL_CONSUMPTION_TRANSACTIONS mct

4298: --THEN
4299: FORALL i IN l_previous_cons_index..l_current_cons_index
4300: --Bug 5092489, Query modified to eliminate use of MMT
4301: UPDATE
4302: MTL_CONSUMPTION_TRANSACTIONS mct
4303: SET mct.batch_id = l_current_batch_id
4304: /* request id stamped to MCT - bug 5200436 - Start*/
4305: , mct.request_id = g_request_id
4306: WHERE mct.transaction_source_id = l_txn_source_tab(i)

Line 4328: -- Update the table MTL_CONSUMPTION_TRANSACTIONS with the

4324:
4325: -- Bug 5092489. l_previous_cons_index has to be set as l_current_cons_index
4326: l_previous_cons_index := l_current_cons_index+1;
4327:
4328: -- Update the table MTL_CONSUMPTION_TRANSACTIONS with the
4329: -- current batch id for Transfer to consigned txns.
4330:
4331:
4332: UPDATE

Line 4333: MTL_CONSUMPTION_TRANSACTIONS mct

4329: -- current batch id for Transfer to consigned txns.
4330:
4331:
4332: UPDATE
4333: MTL_CONSUMPTION_TRANSACTIONS mct
4334: SET mct.batch_id = l_current_batch_id
4335: WHERE mct.parent_transaction_id IN
4336: (SELECT
4337: mct_in.transaction_id

Line 4339: MTL_CONSUMPTION_TRANSACTIONS mct_in

4335: WHERE mct.parent_transaction_id IN
4336: (SELECT
4337: mct_in.transaction_id
4338: FROM
4339: MTL_CONSUMPTION_TRANSACTIONS mct_in
4340: WHERE mct_in.batch_id = l_current_batch_id
4341: --AND mct.consumption_processed_flag <> 'Y');
4342: --Bug 5092489
4343: AND mct_in.consumption_processed_flag IN ('N', 'E'))

Line 4461: -- MTL_CONSUMPTION_TRANSACTIONS to a batch and then call the

4457:
4458: --========================================================================
4459: -- PROCEDURE : Consumption_Txn_Manager PUBLIC
4460: -- COMMENT : This procedure will assign each unprocessed record in
4461: -- MTL_CONSUMPTION_TRANSACTIONS to a batch and then call the
4462: -- Consumption_Transaction_Worker for that batch. The manager
4463: -- will continue until all records
4464: -- in MTL_CONSUMPTION_TRANSACTIONS
4465: -- have been assigned to a batch.

Line 4464: -- in MTL_CONSUMPTION_TRANSACTIONS

4460: -- COMMENT : This procedure will assign each unprocessed record in
4461: -- MTL_CONSUMPTION_TRANSACTIONS to a batch and then call the
4462: -- Consumption_Transaction_Worker for that batch. The manager
4463: -- will continue until all records
4464: -- in MTL_CONSUMPTION_TRANSACTIONS
4465: -- have been assigned to a batch.
4466: --=========================================================================
4467: PROCEDURE consumption_txn_manager
4468: ( p_batch_size IN NUMBER

Line 4563: where exists(select /+ no_unnest / 1 from MTL_CONSUMPTION_TRANSACTIONS mct

4559:
4560: /* Bug 14036045. Performance issue. Modified below query and checking whether record exists or not.*/
4561: begin
4562: select 1 into l_count from dual
4563: where exists(select /*+ no_unnest */ 1 from MTL_CONSUMPTION_TRANSACTIONS mct
4564: where consumption_processed_flag IN ('N', 'E')
4565: AND ( mct.batch_id = l_batch_id OR mct.batch_id IS NULL) AND NVL(net_qty,0) > 0
4566: and exists(select /*+ no_unnest */ 1 from MTL_MATERIAL_TRANSACTIONS mmt
4567: where mct.transaction_id = mmt.transaction_id

Line 4597: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct

4593:
4594: IF l_count > 0 THEN
4595:
4596: --Bug 5092489: New condition added
4597: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct
4598: SET (mct.batch_id, mct.transaction_source_id, mct.inventory_item_id,
4599: mct.accrual_account_id, mct.organization_id,
4600: mct.owning_organization_id, mct.transaction_date)
4601: = (SELECT

Line 4621: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct

4617: AND ( mct.batch_id = l_batch_id OR mct.batch_id IS NULL)
4618: AND mct.po_line_id IS NOT NULL; --bug 11900144
4619:
4620:
4621: UPDATE MTL_CONSUMPTION_TRANSACTIONS mct
4622: SET (mct.global_agreement_flag) =
4623: (SELECT NVL(global_agreement_flag,'N') FROM po_headers_all
4624: WHERE po_header_id = mct.transaction_source_id)
4625: WHERE mct.consumption_processed_flag IN ('N', 'E')

Line 4649: -- in MTL_CONSUMPTION_TRANSACTIONS and call the worker to

4645:
4646: END IF;
4647:
4648: -- Call procedure to assign a batch_id to unprocessed data
4649: -- in MTL_CONSUMPTION_TRANSACTIONS and call the worker to
4650: -- process a batch
4651:
4652: IF (l_debug = 1)
4653: THEN