[Home] [Help]
47: , rt.primary_quantity
48: , rt.transaction_type
49: FROM mtl_system_items msi
50: , rcv_transactions rt
51: , po_lines_all pl
52: WHERE rt.transaction_id = p_rcv_trx_id
53: AND rt.po_line_id = pl.po_line_id
54: AND msi.inventory_item_id = pl.item_id
55: AND msi.organization_id = rt.organization_id;
3032: wediv.po_release_id /* Bug 5201970 */
3033: FROM po_distributions_all pda,
3034: po_line_locations_all plla,
3035: po_headers_all pha,
3036: po_lines_all pla,
3037: cst_eam_direct_items_temp wediv
3038: WHERE wediv.work_order_number = p_wip_entity_id
3039: AND wediv.organization_id = l_organization_id
3040: AND wediv.task_number = pda.wip_operation_seq_num
5130: cedi.req_authorization_status req_auth_status
5131: FROM po_distributions_all pda,
5132: po_line_locations_all plla,
5133: po_headers_all pha,
5134: po_lines_all pla,
5135: cst_eam_direct_items_temp cedi
5136: WHERE cedi.work_order_number = p_wip_entity_id
5137: AND cedi.organization_id = l_organization_id
5138: AND cedi.task_number = pda.wip_operation_seq_num
6273: l_curr_code,
6274: l_po_order_type_lookup_code
6275: from po_distributions_all pod,
6276: rcv_transactions_interface rti,
6277: po_lines_all pol
6278: where rti.interface_transaction_id = l_interface_txn_id
6279: and pod.po_distribution_id = rti.po_distribution_id
6280: and pol.po_header_id=pod.po_header_id
6281: and pol.po_line_id=pod.po_line_id; */
6372: l_item_id,
6373: l_source_doc_unit_of_measure
6374: from rcv_transactions rti,
6375: po_distributions_all pod,
6376: po_lines_all pol
6377: where rti.transaction_id = l_txn_id
6378: and rti.po_distribution_id = pod.po_distribution_id
6379: and pol.po_line_id = pod.po_line_id;
6380:
9274: l_statement := 70;
9275: if (l_po_line_id <> -1) then
9276: select nvl(pla.category_id, -1)
9277: into l_category_id
9278: from po_lines_all pla
9279: where pla.po_line_id = l_po_line_id;
9280: else
9281: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9282: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9592: l_statement := 70;
9593: if (l_po_line_id <> -1) then
9594: select nvl(pla.category_id, -1)
9595: into l_category_id
9596: from po_lines_all pla
9597: where pla.po_line_id = l_po_line_id;
9598: else
9599: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9600: l_api_message := l_api_message || ' wip_transactions ';
10654: pol.line_type_id,
10655: pd1.po_header_id,
10656: pd1.project_id,
10657: pol.org_id
10658: FROM po_lines_all pol,
10659: po_distributions_all pd1
10660: WHERE pol.po_line_id = pd1.po_line_id AND
10661: pd1.wip_entity_id = p_entity_id_tab(l_index)
10662: ) pd
11121: l_po_document_type_code,
11122: l_po_encumbrance_amount
11123: FROM po_headers_all POH,
11124: po_line_locations_all POLL,
11125: po_lines_all POL,
11126: po_distributions_all POD,
11127: rcv_transactions RT
11128: WHERE RT.transaction_id = p_receiving_transaction_id
11129: AND POH.po_header_id = RT.po_header_id