DBA Data[Home] [Help]

APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on OE_ORDER_LINES_ALL

Line 323: FROM oe_order_lines_all

319: IF p_txn_source_name = 'ORDER_ENTRY' THEN
320:
321: SELECT 'X'
322: INTO l_found
323: FROM oe_order_lines_all
324: WHERE line_id = p_txn_source_id;
325:
326: x_return_status := fnd_api.g_ret_sts_success;
327:

Line 561: l_mo_org_id oe_order_lines_all.org_id%type;

557: l_src_organization_id mtl_parameters.organization_id%TYPE;
558: l_src_quantity NUMBER;
559: l_src_uom_code VARCHAR2(3);
560: l_src_primary_qty NUMBER;
561: l_mo_org_id oe_order_lines_all.org_id%type;
562:
563: l_inst_item_id csi_item_instances.inventory_item_id%type;
564: l_inst_organization_id csi_item_instances.inv_organization_id%type;
565: l_inst_quantity csi_item_instances.quantity%type;

Line 721: IF p_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN

717: END IF; -- quantity chk for td with source txn flag - 'Y'
718:
719:
720: /* check the location_type_code for the source */
721: IF p_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN
722:
723: IF nvl(p_txn_line_dtl_tbl(l_index).location_id , fnd_api.g_miss_num) <>
724: fnd_api.g_miss_num
725: THEN