[Home] [Help]
998: IF l_source_document_code = 'PO' THEN
999: INL_LOGGING_PVT.Log_Statement (
1000: p_module_name => g_module_name,
1001: p_procedure_name => l_proc_name,
1002: p_debug_info => 'Get values from zx_lines_det_factors and po_line_locations_all');
1003:
1004:
1005: SELECT zdf.trx_business_category,
1006: zdf.line_intended_use,
1018: l_user_defined_fisc_class,
1019: l_output_tax_classf_code,
1020: l_po_UOM_code --Bug#9884458
1021: FROM zx_lines_det_factors zdf,
1022: po_line_locations_all pll,
1023: po_lines_all pl, --Bug#9884458
1024: mtl_units_of_measure muom --Bug#9884458
1025: WHERE pll.line_location_id = p_int_rec(i).po_line_location_id
1026: AND pll.po_line_id = pl.po_line_id --Bug#9884458
2916: pll.matching_basis,
2917: 'Y' lcm_flag
2918: FROM po_headers_all ph,
2919: po_lines_all pl,
2920: po_line_locations_all pll,
2921: po_releases_all pr -- Bug 9734841
2922: WHERE ph.po_header_id = p_po_header_id
2923: AND pl.po_header_id = ph.po_header_id
2924: AND pll.po_line_id = pl.po_line_id
3072: p_procedure_name => l_proc_name,
3073: p_var_name => 'l_party_site_id',
3074: p_var_value => l_party_site_id);
3075:
3076: -- Open Po Line Locations cursor
3077: OPEN c_pll (p_po_hdr_rec.po_header_id,
3078: p_po_hdr_rec.po_release_id, -- Bug 14280113
3079: p_po_hdr_rec.vendor_id,
3080: p_po_hdr_rec.vendor_site_id);
3111:
3112: l_lci_table(l_ind_lci).landed_cost_flag := l_landed_cost_flag; -- Bug 9814077
3113: l_lci_table(l_ind_lci).allocation_enabled_flag := l_allocation_enabled_flag; -- Bug 9814077
3114:
3115: l_lci_table(l_ind_lci).line_interface_source_table := 'PO_LINE_LOCATIONS';
3116: l_lci_table(l_ind_lci).ship_line_src_type_code := 'PO';
3117:
3118: l_lci_table(l_ind_lci).ship_date := NVL(p_po_hdr_rec.approved_date,SYSDATE);
3119: l_lci_table(l_ind_lci).ship_type_id := l_ship_type_id;
3311: l_lci_table(l_ind_lci).product_type,
3312: l_lci_table(l_ind_lci).user_def_fiscal_class,
3313: l_lci_table(l_ind_lci).tax_classification_code
3314: FROM zx_lines_det_factors zdf,
3315: po_line_locations_all pll
3316: WHERE pll.line_location_id = c_pll_tab(i).line_location_id
3317: AND zdf.application_id = 201
3318: AND zdf.trx_id = NVL(pll.po_release_id,pll.po_header_id)
3319: AND zdf.trx_line_id = pll.line_location_id
3813: SELECT pll.line_location_id,
3814: pll.shipment_num,
3815: pl.line_num,
3816: ph.segment1
3817: FROM po_line_locations pll,
3818: po_lines pl,
3819: po_headers ph,
3820: inl_simulations s
3821: WHERE INV_UTILITIES.inv_check_lcm(
3863: p_var_value => p_simulation_id);
3864:
3865: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
3866: p_procedure_name => l_proc_name,
3867: p_debug_info => 'Get PO Line Locations for Simulation');
3868:
3869: SELECT meaning
3870: INTO l_src_type
3871: FROM fnd_lookup_values_vl l
3871: FROM fnd_lookup_values_vl l
3872: WHERE l.lookup_type = 'INL_SHIP_LINE_SRC_TYPES'
3873: AND l.lookup_code = 'PO';
3874:
3875: -- Open PO Line Locations cursor
3876: OPEN c_po_ln_loc;
3877: FETCH c_po_ln_loc BULK COLLECT INTO c_po_ln_loc_tab;
3878: CLOSE c_po_ln_loc;
3879:
4044: l_po_ln_cancel_flag,
4045: l_po_ln_num,
4046: l_po_currency,
4047: l_po_number
4048: FROM po_line_locations pll,
4049: po_lines pl,
4050: po_headers ph
4051: WHERE ph.po_header_id = pl.po_header_id
4052: AND pl.po_line_id = pll.po_line_id
4718: pl.item_id,
4719: pll.ship_to_organization_id
4720: FROM po_headers_all ph,
4721: po_lines_all pl,
4722: po_line_locations_all pll
4723: WHERE ph.po_header_id = pl.po_header_id
4724: AND pl.po_line_id = pll.po_line_id
4725: AND ph.po_header_id = p_po_header_id;
4726: