APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_ASL_ATTRIBUTES

Line 7032: PO_ASL_ATTRIBUTES PAA,

7028: FROM PO_LINES_GT POL,
7029: PO_HEADERS_GT POH,
7030: PO_LINE_LOCATIONS_GT PLL,
7031: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL,
7032: PO_ASL_ATTRIBUTES PAA,
7033: PO_ASL_STATUS_RULES_V PASR
7034:
7035: WHERE POH.po_header_id = p_document_id
7036: AND POL.po_header_id = POH.po_header_id

Line 7058: FROM po_asl_attributes paa2

7054: AND PASL.asl_id = PAA.asl_id
7055: AND PAA.enable_vmi_flag = 'Y'
7056: AND PAA.using_organization_id =
7057: (SELECT max(paa2.using_organization_id)
7058: FROM po_asl_attributes paa2
7059: WHERE paa2.asl_id = pasl.asl_id
7060: AND paa2.using_organization_id IN (-1, PLL.ship_to_organization_id));
7061:
7062: END IF;

Line 8188: po_asl_attributes.consigned_from_supplier_flag%TYPE := NULL;

8184: l_progress VARCHAR2(3);
8185:
8186: l_textline po_online_report_text.text_line%TYPE := NULL;
8187: l_consigned_from_supplier_flag
8188: po_asl_attributes.consigned_from_supplier_flag%TYPE := NULL;
8189: l_enable_vmi_flag
8190: po_asl_attributes.enable_vmi_flag%TYPE := NULL;
8191: l_last_billing_date DATE := NULL;
8192: l_consigned_billing_cycle NUMBER := NULL;

Line 8190: po_asl_attributes.enable_vmi_flag%TYPE := NULL;

8186: l_textline po_online_report_text.text_line%TYPE := NULL;
8187: l_consigned_from_supplier_flag
8188: po_asl_attributes.consigned_from_supplier_flag%TYPE := NULL;
8189: l_enable_vmi_flag
8190: po_asl_attributes.enable_vmi_flag%TYPE := NULL;
8191: l_last_billing_date DATE := NULL;
8192: l_consigned_billing_cycle NUMBER := NULL;
8193: l_consigned_mismatch_found BOOLEAN := FALSE;
8194: l_count_expense_dist NUMBER := NULL;

Line 8198: po_asl_attributes.consigned_from_supplier_flag%TYPE

8194: l_count_expense_dist NUMBER := NULL;
8195:
8196: TYPE NumTab is TABLE of NUMBER INDEX by BINARY_INTEGER;
8197: TYPE AslConsignedFlagTab is TABLE of
8198: po_asl_attributes.consigned_from_supplier_flag%TYPE
8199: INDEX by BINARY_INTEGER;
8200: TYPE ConsignedFlagTab is TABLE of
8201: po_line_locations.consigned_flag%TYPE
8202: INDEX by BINARY_INTEGER;