DBA Data[Home] [Help]

APPS.INV_INVTRDST_XMLP_PKG dependencies on CST_COST_UPDATES

Line 517: RETURN ('cst_cost_updates cst,');

513: IF P_SOURCE_TYPE_ID = 10 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
514: RETURN ('mtl_physical_inventories pi,');
515: END IF;
516: IF P_SOURCE_TYPE_ID = 11 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
517: RETURN ('cst_cost_updates cst,');
518: END IF;
519: END;
520: RETURN ' ';
521: END C_SOURCE_FROMFORMULA;

Line 796: from cst_cost_updates

792: and organization_id = org_id;
793: return(txn_source);
794: elsif Type_id = 11 then
795: select description into txn_source
796: from cst_cost_updates
797: where cost_update_id = to_number(txn_source_id);
798: return(txn_source);
799: /*elsif Type_id in (2,8,12) then
800: BEGIN

Line 875: from cst_cost_updates

871: and organization_id = org_id;
872: return(txn_source);
873: elsif Type_id1 = 11 then
874: select description into txn_source
875: from cst_cost_updates
876: where cost_update_id = to_number(txn_source_id);
877: return(txn_source);
878: /*elsif Type_id1 in (2,8,12) then
879: BEGIN

Line 954: from cst_cost_updates

950: and organization_id = org_id;
951: return(txn_source);
952: elsif Type_id2 = 11 then
953: select description into txn_source
954: from cst_cost_updates
955: where cost_update_id = to_number(txn_source_id);
956: return(txn_source);
957: /*elsif Type_id2 in (2,8,12) then
958: BEGIN

Line 1033: from cst_cost_updates

1029: and organization_id = org_id;
1030: return(txn_source);
1031: elsif Type_id3 = 11 then
1032: select description into txn_source
1033: from cst_cost_updates
1034: where cost_update_id = to_number(txn_source_id);
1035: return(txn_source);
1036: /*elsif Type_id3 in (2,8,12) then
1037: BEGIN

Line 1112: from cst_cost_updates

1108: and organization_id = org_id;
1109: return(txn_source);
1110: elsif Type_id4 = 11 then
1111: select description into txn_source
1112: from cst_cost_updates
1113: where cost_update_id = to_number(txn_source_id);
1114: return(txn_source);
1115: /*elsif Type_id4 in (2,8,12) then
1116: BEGIN