APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_ASL_ATTRIBUTES

Line 9699: PO_ASL_ATTRIBUTES PAA,

9695: FROM PO_LINES_GT POL,
9696: PO_HEADERS_GT POH,
9697: PO_LINE_LOCATIONS_GT PLL,
9698: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL,
9699: PO_ASL_ATTRIBUTES PAA,
9700: PO_ASL_STATUS_RULES_V PASR
9701:
9702: WHERE POH.po_header_id = p_document_id
9703: AND POL.po_header_id = POH.po_header_id

Line 9725: FROM po_asl_attributes paa2

9721: AND PASL.asl_id = PAA.asl_id
9722: AND PAA.enable_vmi_flag = 'Y'
9723: AND PAA.using_organization_id =
9724: (SELECT max(paa2.using_organization_id)
9725: FROM po_asl_attributes paa2
9726: WHERE paa2.asl_id = pasl.asl_id
9727: AND paa2.using_organization_id IN (-1, PLL.ship_to_organization_id));
9728:
9729: END IF;

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

11400: l_progress VARCHAR2(3);
11401:
11402: l_textline po_online_report_text.text_line%TYPE := NULL;
11403: l_consigned_from_supplier_flag
11404: po_asl_attributes.consigned_from_supplier_flag%TYPE := NULL;
11405: l_enable_vmi_flag
11406: po_asl_attributes.enable_vmi_flag%TYPE := NULL;
11407: l_last_billing_date DATE := NULL;
11408: l_consigned_billing_cycle NUMBER := NULL;

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

11402: l_textline po_online_report_text.text_line%TYPE := NULL;
11403: l_consigned_from_supplier_flag
11404: po_asl_attributes.consigned_from_supplier_flag%TYPE := NULL;
11405: l_enable_vmi_flag
11406: po_asl_attributes.enable_vmi_flag%TYPE := NULL;
11407: l_last_billing_date DATE := NULL;
11408: l_consigned_billing_cycle NUMBER := NULL;
11409: l_consigned_mismatch_found BOOLEAN := FALSE;
11410: l_count_expense_dist NUMBER := NULL;

Line 11414: po_asl_attributes.consigned_from_supplier_flag%TYPE

11410: l_count_expense_dist NUMBER := NULL;
11411:
11412: TYPE NumTab is TABLE of NUMBER INDEX by BINARY_INTEGER;
11413: TYPE AslConsignedFlagTab is TABLE of
11414: po_asl_attributes.consigned_from_supplier_flag%TYPE
11415: INDEX by BINARY_INTEGER;
11416: TYPE ConsignedFlagTab is TABLE of
11417: po_line_locations.consigned_flag%TYPE
11418: INDEX by BINARY_INTEGER;