DBA Data[Home] [Help]

APPS.CSTPLENG dependencies on MTL_SALES_ORDERS

Line 468: from mtl_sales_orders

464: elsif (i_txn_src_type = 2) then
465: /* Sales Order, use Order Number */
466: select segment1
467: into l_src_number
468: from mtl_sales_orders
469: where sales_order_id = i_src_id;
470: elsif (i_txn_src_type = 3) then
471: /* Account, use Account # */
472: select concatenated_segments

Line 500: from mtl_sales_orders

496: elsif (i_txn_src_type = 8) then
497: /* internal order, use order number */
498: select segment1
499: into l_src_number
500: from mtl_sales_orders
501: where sales_order_id = i_src_id;
502: elsif (i_txn_src_type = 9) then
503: /* Cycle count, use cycle count header name */
504: select cycle_count_header_name

Line 518: from mtl_sales_orders

514: elsif (i_txn_src_type = 12) then
515: /* RMA, use sales order number */
516: select segment1
517: into l_src_number
518: from mtl_sales_orders
519: where sales_order_id = i_src_id;
520: elsif (i_txn_src_type = 13) then
521: /* Inventory, use distribution account ID */
522: select concatenated_segments