APPS.PO_COPYDOC_SUB dependencies on PO_LINE_TYPES

Line 975: FROM PO_LINE_TYPES PLT

971: AND MSI.organization_id = x_inv_org_id
972: AND (MSI.outside_operation_flag <> 'Y'
973: OR (MSI.outside_operation_flag = 'Y'
974: AND EXISTS (SELECT 'op line type'
975: FROM PO_LINE_TYPES PLT
976: WHERE PLT.line_type_id = x_line_type_id
977: AND PLT.outside_operation_flag = 'Y')
978: )
979: );

Line 1006: FROM PO_LINE_TYPES

1002: x_progress := '002';
1003: BEGIN
1004: SELECT distinct 'Y'
1005: INTO x_valid_flag
1006: FROM PO_LINE_TYPES
1007: WHERE line_type_id = x_line_type_id
1008: AND order_type_lookup_code <> 'AMOUNT';
1009: EXCEPTION
1010: WHEN NO_DATA_FOUND THEN

Line 1733: FROM PO_LINE_TYPES PLT, PO_LINES POL

1729: BEGIN
1730:
1731: SELECT NVL(PLT.OUTSIDE_OPERATION_FLAG,'N')
1732: INTO x_osp_line_flag
1733: FROM PO_LINE_TYPES PLT, PO_LINES POL
1734: WHERE PLT.LINE_TYPE_ID = POL.LINE_TYPE_ID
1735: AND POL.PO_LINE_ID = x_po_line_id;
1736:
1737: EXCEPTION