DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on STANDARD

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

1962: x_count :=null;
1963: x_progress := '20';
1964: -- is this a valid operation sequence
1965: -- Bug 3557910. The eAM operation may not be
1966: -- a standard operation. Hence we need to outer join BSO.
1967: if x_wip_operation_seq_num is not null then
1968: if x_entity_type =6 then --6 stands for eAM work orders
1969: select count(*)
1970: INTO x_count

Line 1972: BOM_STANDARD_OPERATIONS BSO

1968: if x_entity_type =6 then --6 stands for eAM work orders
1969: select count(*)
1970: INTO x_count
1971: from WIP_OPERATIONS WO,
1972: BOM_STANDARD_OPERATIONS BSO
1973: WHERE WO.WIP_ENTITY_ID=x_wip_entity_id
1974: AND operation_seq_num=x_wip_operation_seq_num
1975: AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+) --Bug 3557910 Added Outer JOIN
1976: AND nvl(BSO.OPERATION_TYPE,1) =1

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

1971: from WIP_OPERATIONS WO,
1972: BOM_STANDARD_OPERATIONS BSO
1973: WHERE WO.WIP_ENTITY_ID=x_wip_entity_id
1974: AND operation_seq_num=x_wip_operation_seq_num
1975: AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+) --Bug 3557910 Added Outer JOIN
1976: AND nvl(BSO.OPERATION_TYPE,1) =1
1977: AND BSO.line_id is null;
1978:
1979: else

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

2671: x_shipment_num := x_po_shipment_record.shipment_num;
2672: -- Get each shipment and validate shipment info:
2673:
2674: --< Shared Proc FPJ Start >
2675: IF (x_po_shipment_record.shipment_type = 'STANDARD') THEN
2676: validate_transaction_flow
2677: (p_ship_to_org_id => x_po_shipment_record.ship_to_organization_id,
2678: p_transaction_flow_header_id =>
2679: x_po_shipment_record.transaction_flow_header_id,