APPS.WIP_OSP dependencies on STANDARD

Line 920: -- AND ((PH.TYPE_LOOKUP_CODE = 'STANDARD' AND

916: -- check cancel flag at shipment level instead of at header level
917: -- because PO will cancel upto shipment level
918: AND (pll.cancel_flag IS NULL OR
919: pll.cancel_flag = 'N')
920: -- AND ((PH.TYPE_LOOKUP_CODE = 'STANDARD' AND
921: -- nvl(PH.CANCEL_FLAG,'N') ='N')
922: -- OR
923: -- (PH.TYPE_LOOKUP_CODE = 'BLANKET' AND
924: -- PR.PO_RELEASE_ID = PD.PO_RELEASE_ID AND

Line 967: -- AND ((PH.TYPE_LOOKUP_CODE = 'STANDARD' AND

963: -- because PO will cancel upto shipment level
964: AND (pll.cancel_flag IS NULL OR
965: pll.cancel_flag = 'N')
966: AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED'
967: -- AND ((PH.TYPE_LOOKUP_CODE = 'STANDARD' AND
968: -- nvl(PH.CANCEL_FLAG, 'N') = 'N' )
969: -- OR
970: -- (PH.TYPE_LOOKUP_CODE = 'BLANKET' AND
971: -- nvl(PR.CANCEL_FLAG, 'N') = 'N'))

Line 1359: WHERE ph.type_lookup_code = 'STANDARD'

1355: po_headers_all ph,
1356: po_lines_all pl,
1357: po_line_locations_all pll,
1358: po_line_types plt
1359: WHERE ph.type_lookup_code = 'STANDARD'
1360: AND ph.po_header_id = pd.po_header_id
1361: AND pd.po_line_id = pl.po_line_id
1362: AND pd.line_location_id = pll.line_location_id
1363: AND pl.line_type_id = plt.line_type_id

Line 1609: IF(p_po_req_type IN('STANDARD', 'BLANKET')) THEN

1605: -- Set OU context before calling PO API. This change is mandatory for
1606: -- MOAC change in R12.
1607: mo_global.set_policy_context('S',p_ou_id);
1608: -- Update PO need by date and promise date
1609: IF(p_po_req_type IN('STANDARD', 'BLANKET')) THEN
1610: IF(p_approval_status IS NULL OR -- INCOMPLETE
1611: p_approval_status IN('INCOMPLETE',
1612: 'APPROVED',
1613: 'REQUIRES REAPPROVAL')) THEN

Line 1853: WHERE ph.type_lookup_code = 'STANDARD'

1849: wip_operation_resources wor,
1850: wip_operations wo,
1851: wip_discrete_jobs wdj,
1852: wip_repetitive_schedules wrs
1853: WHERE ph.type_lookup_code = 'STANDARD'
1854: AND ph.po_header_id = pd.po_header_id
1855: AND pd.line_location_id = pll.line_location_id
1856: AND pd.po_line_id = pl.po_line_id
1857: AND pd.wip_entity_id = wdj.wip_entity_id (+)

Line 2114: IF (l_update_po_qty.po_req_type IN ('STANDARD', 'BLANKET')) THEN

2110: FOR l_update_po_qty IN c_update_po_qty LOOP
2111: -- Set OU context before calling PO API. This change is
2112: -- mandatory for MOAC change in R12.
2113: mo_global.set_policy_context('S',l_update_po_qty.ou_id);
2114: IF (l_update_po_qty.po_req_type IN ('STANDARD', 'BLANKET')) THEN
2115: IF (l_update_po_qty.approval_status IS NULL OR -- INCOMPLETE
2116: l_update_po_qty.approval_status IN ('INCOMPLETE',
2117: 'APPROVED',
2118: 'REQUIRES REAPPROVAL')) THEN

Line 2283: AND ph.type_lookup_code = 'STANDARD'

2279: po_line_locations_all pll
2280: /* Fixed bug 3115844 */
2281: WHERE pd.po_line_id IS NOT NULL
2282: AND pd.line_location_id IS NOT NULL
2283: AND ph.type_lookup_code = 'STANDARD'
2284: AND ph.po_header_id = pd.po_header_id
2285: AND pd.line_location_id = pll.line_location_id
2286: AND pd.wip_entity_id = p_job_id
2287: AND pd.destination_organization_id = p_org_id

Line 2386: IF (l_po_req.po_req_type IN ('STANDARD', 'BLANKET'))THEN

2382: BEGIN
2383: -- Set OU context before calling PO API. This change is
2384: -- mandatory for MOAC change in R12.
2385: mo_global.set_policy_context('S',l_po_req.ou_id);
2386: IF (l_po_req.po_req_type IN ('STANDARD', 'BLANKET'))THEN
2387: -- Call PO API to cancel PO/release. If unable to cancel PO/release
2388: -- for any reason,skip the error one and try to cancel the next one.
2389:
2390: IF (l_logLevel <= wip_constants.full_logging) THEN