DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on STANDARD

Line 1821: -- a standard operation. Hence we need to outer join BSO.

1817: x_count :=null;
1818: x_progress := '20';
1819: -- is this a valid operation sequence
1820: -- Bug 3557910. The eAM operation may not be
1821: -- a standard operation. Hence we need to outer join BSO.
1822: if x_wip_operation_seq_num is not null then
1823: if x_entity_type =6 then --6 stands for eAM work orders
1824: select count(*)
1825: INTO x_count

Line 1827: BOM_STANDARD_OPERATIONS BSO

1823: if x_entity_type =6 then --6 stands for eAM work orders
1824: select count(*)
1825: INTO x_count
1826: from WIP_OPERATIONS WO,
1827: BOM_STANDARD_OPERATIONS BSO
1828: WHERE WO.WIP_ENTITY_ID=x_wip_entity_id
1829: AND operation_seq_num=x_wip_operation_seq_num
1830: AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+) --Bug 3557910 Added Outer JOIN
1831: AND nvl(BSO.OPERATION_TYPE,1) =1

Line 1830: AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+) --Bug 3557910 Added Outer JOIN

1826: from WIP_OPERATIONS WO,
1827: BOM_STANDARD_OPERATIONS BSO
1828: WHERE WO.WIP_ENTITY_ID=x_wip_entity_id
1829: AND operation_seq_num=x_wip_operation_seq_num
1830: AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+) --Bug 3557910 Added Outer JOIN
1831: AND nvl(BSO.OPERATION_TYPE,1) =1
1832: AND BSO.line_id is null;
1833:
1834: else

Line 2500: IF (x_po_shipment_record.shipment_type = 'STANDARD') THEN

2496: x_shipment_num := x_po_shipment_record.shipment_num;
2497: -- Get each shipment and validate shipment info:
2498:
2499: --< Shared Proc FPJ Start >
2500: IF (x_po_shipment_record.shipment_type = 'STANDARD') THEN
2501: validate_transaction_flow
2502: (p_ship_to_org_id => x_po_shipment_record.ship_to_organization_id,
2503: p_transaction_flow_header_id =>
2504: x_po_shipment_record.transaction_flow_header_id,