DBA Data[Home] [Help]

APPS.POS_CREATE_ASN dependencies on PO_DISTRIBUTIONS

Line 109: from po_distributions

105: select WIP_ENTITY_ID ,
106: WIP_LINE_ID ,
107: WIP_OPERATION_SEQ_NUM ,
108: PO_DISTRIBUTION_ID
109: from po_distributions
110: where line_location_id = linelocid;
111:
112: dis_details_rec dis_details_cur%rowtype;
113:

Line 662: l_distribution_type po_distributions_all.distribution_type%TYPE;

658: x_primary_uom VARCHAR2(26);
659: x_interface_qty_in_po_uom NUMBER := 0;
660:
661: l_line_location_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
662: l_distribution_type po_distributions_all.distribution_type%TYPE;
663: l_matching_basis po_line_locations_all.matching_basis%TYPE;
664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;
666: l_budget_account_id po_distributions_all.budget_account_id%TYPE;

Line 664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;

660:
661: l_line_location_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
662: l_distribution_type po_distributions_all.distribution_type%TYPE;
663: l_matching_basis po_line_locations_all.matching_basis%TYPE;
664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;
666: l_budget_account_id po_distributions_all.budget_account_id%TYPE;
667: l_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
668: l_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;

Line 665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;

661: l_line_location_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
662: l_distribution_type po_distributions_all.distribution_type%TYPE;
663: l_matching_basis po_line_locations_all.matching_basis%TYPE;
664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;
666: l_budget_account_id po_distributions_all.budget_account_id%TYPE;
667: l_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
668: l_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
669: l_funded_value NUMBER;

Line 666: l_budget_account_id po_distributions_all.budget_account_id%TYPE;

662: l_distribution_type po_distributions_all.distribution_type%TYPE;
663: l_matching_basis po_line_locations_all.matching_basis%TYPE;
664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;
666: l_budget_account_id po_distributions_all.budget_account_id%TYPE;
667: l_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
668: l_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
669: l_funded_value NUMBER;
670: l_quantity_funded NUMBER;

Line 667: l_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;

663: l_matching_basis po_line_locations_all.matching_basis%TYPE;
664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;
666: l_budget_account_id po_distributions_all.budget_account_id%TYPE;
667: l_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
668: l_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
669: l_funded_value NUMBER;
670: l_quantity_funded NUMBER;
671: l_amount_funded NUMBER;