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.WIP_PICKING_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 543: from MTL_TXN_REQUEST_LINES mtrl

539: begin
540: -- Modified Query for performance bug 8561606 (FP 8523754).
541: select mtrl.transaction_type_id
542: into l_txn_type_id
543: from MTL_TXN_REQUEST_LINES mtrl
544: where
545: mtrl.TXN_SOURCE_ID = p_wip_entity_id and
546: mtrl.TXN_SOURCE_LINE_ID = p_operation_seq_num and
547: mtrl.organization_id = p_organization_id and

Line 578: from MTL_TXN_REQUEST_LINES mtrl

574: begin
575: if (l_txn_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE) then
576: select sum(nvl(mtrl.quantity,0) - nvl(mtrl.quantity_delivered,0))
577: into l_quantity_allocated
578: from MTL_TXN_REQUEST_LINES mtrl
579: where
580: mtrl.TXN_SOURCE_ID = p_wip_entity_id and
581: mtrl.TXN_SOURCE_LINE_ID = p_operation_seq_num and
582: ( p_repetitive_schedule_id is null or

Line 593: from MTL_TXN_REQUEST_LINES mtrl

589: mtrl.TXN_SOURCE_LINE_ID, mtrl.INVENTORY_ITEM_ID;
590: else
591: select sum(nvl(mtrl.quantity,0))
592: into l_mtrl_quantity
593: from MTL_TXN_REQUEST_LINES mtrl
594: where
595: mtrl.TXN_SOURCE_ID = p_wip_entity_id and
596: mtrl.TXN_SOURCE_LINE_ID = p_operation_seq_num and
597: ( p_repetitive_schedule_id is null or

Line 619: from MTL_TXN_REQUEST_LINES mtrl

615: into l_dummy
616: from dual
617: where exists
618: ( select 1
619: from MTL_TXN_REQUEST_LINES mtrl
620: where
621: mtrl.backorder_delivery_detail_id = p_wip_entity_id and
622: mtrl.TXN_SOURCE_LINE_ID is null and
623: ( p_repetitive_schedule_id is null or

Line 673: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead

669: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
670: begin
671: /*Bug 12861942 The original query don't make sense because its purpose is for checking if
672: there are existing/pending move order lines, while quantity_backordered doesn't have much relation
673: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead
674: Select 1 Into l_dummy
675: from wip_requirement_operations
676: Where wip_entity_id = p_wip_entity_id
677: And Organization_id = p_org_id

Line 684: from MTL_TXN_REQUEST_LINES

680: And quantity_backordered is not null
681: And quantity_backordered <> 0;
682: */
683: select 1 into l_dummy
684: from MTL_TXN_REQUEST_LINES
685: Where txn_source_id = p_wip_entity_id
686: And Organization_id = p_org_id
687: --And operation_seq_num = p_operation_seq_num
688: And inventory_item_id = nvl(p_inventory_item_id, inventory_item_id)

Line 699: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead

695: begin
696: /*
697: Bug 12861942 The original query don't make sense because its purpose is for checking if
698: there are existing/pending move order lines, while quantity_backordered doesn't have much relation
699: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead
700:
701: Select 1 Into l_dummy
702: from wip_requirement_operations
703: Where wip_entity_id = p_wip_entity_id

Line 711: from MTL_TXN_REQUEST_LINES

707: And inventory_item_id = nvl(p_inventory_item_id, inventory_item_id) */
708:
709:
710: Select 1 Into l_dummy
711: from MTL_TXN_REQUEST_LINES
712: Where txn_source_id = p_wip_entity_id
713: And repetitive_schedule_id = p_repetitive_schedule_id
714: And Organization_id = p_org_id
715: --And operation_seq_num = p_operation_seq_num

Line 744: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead

740: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
741: begin
742: /* Bug 12861942 The original query don't make sense because its purpose is for checking if
743: there are existing/pending move order lines, while quantity_backordered doesn't have much relation
744: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead
745: Select 1 Into l_dummy
746: From dual
747: Where exists
748: (select 1

Line 756: from MTL_TXN_REQUEST_LINES

752: And quantity_backordered is not null
753: And quantity_backordered <> 0);
754: */
755: select 1 into l_dummy
756: from MTL_TXN_REQUEST_LINES
757: Where txn_source_id = p_wip_entity_id
758: And Organization_id = p_org_id
759: And rownum = 1;
760: exception

Line 768: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead

764: Else
765: begin
766: /* Bug 12861942 The original query don't make sense because its purpose is for checking if
767: there are existing/pending move order lines, while quantity_backordered doesn't have much relation
768: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead
769: Select 1 Into l_dummy
770: From dual
771: Where exists
772: (select 1

Line 781: from MTL_TXN_REQUEST_LINES

777: And quantity_backordered is not null
778: And quantity_backordered <> 0);
779: */
780: Select 1 Into l_dummy
781: from MTL_TXN_REQUEST_LINES
782: Where txn_source_id = p_wip_entity_id
783: And repetitive_schedule_id = p_repetitive_schedule_id
784: And Organization_id = p_org_id
785: And rownum = 1;