APPS.PO_COPYDOC_SUB dependencies on PO_LINE_TYPES

Line 929: FROM PO_LINE_TYPES PLT

925: AND MSI.organization_id = x_inv_org_id
926: AND (MSI.outside_operation_flag <> 'Y'
927: OR (MSI.outside_operation_flag = 'Y'
928: AND EXISTS (SELECT 'op line type'
929: FROM PO_LINE_TYPES PLT
930: WHERE PLT.line_type_id = x_line_type_id
931: AND PLT.outside_operation_flag = 'Y')
932: )
933: );

Line 960: FROM PO_LINE_TYPES

956: x_progress := '002';
957: BEGIN
958: SELECT distinct 'Y'
959: INTO x_valid_flag
960: FROM PO_LINE_TYPES
961: WHERE line_type_id = x_line_type_id
962: AND order_type_lookup_code <> 'AMOUNT';
963: EXCEPTION
964: WHEN NO_DATA_FOUND THEN

Line 1597: FROM PO_LINE_TYPES PLT, PO_LINES POL

1593: BEGIN
1594:
1595: SELECT NVL(PLT.OUTSIDE_OPERATION_FLAG,'N')
1596: INTO x_osp_line_flag
1597: FROM PO_LINE_TYPES PLT, PO_LINES POL
1598: WHERE PLT.LINE_TYPE_ID = POL.LINE_TYPE_ID
1599: AND POL.PO_LINE_ID = x_po_line_id;
1600:
1601: EXCEPTION