eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_OA_UTIL dependencies on XDP_ORDER_HEADERS

Line 740: from xdp_order_headers

736:
737: return_code := 0;
738: SAVEPOINT lv_order_tag2;
739: select status_code into lv_curr_state
740: from xdp_order_headers
741: where order_id = p_curr_sdp_order_id;
742:
743: select status_code into lv_rel_state
744: from xdp_order_headers

Line 744: from xdp_order_headers

740: from xdp_order_headers
741: where order_id = p_curr_sdp_order_id;
742:
743: select status_code into lv_rel_state
744: from xdp_order_headers
745: where order_id = p_related_sdp_order_id;
746:
747: IF p_order_relationship = XDP_TYPES.IS_PREREQUISITE_OF OR
748: p_order_relationship = XDP_TYPES.COMES_BEFORE

Line 820: update xdp_order_headers

816: sysdate,
817: FND_GLOBAL.LOGIN_ID
818: );
819:
820: update xdp_order_headers
821: set
822: last_updated_by = FND_GLOBAL.USER_ID,
823: last_update_date = sysdate,
824: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 828: update xdp_order_headers

824: last_update_login = FND_GLOBAL.LOGIN_ID,
825: next_order_id = p_related_sdp_order_id
826: where order_id = p_curr_sdp_order_id;
827:
828: update xdp_order_headers
829: set
830: last_updated_by = FND_GLOBAL.USER_ID,
831: last_update_date = sysdate,
832: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 847: update xdp_order_headers

843: ORDER_RELATIONSHIP = lv_relation
844: where order_id = p_curr_sdp_order_id AND
845: related_order_id = p_related_sdp_order_id;
846:
847: update xdp_order_headers
848: set
849: last_updated_by = FND_GLOBAL.USER_ID,
850: last_update_date = sysdate,
851: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 855: update xdp_order_headers

851: last_update_login = FND_GLOBAL.LOGIN_ID,
852: next_order_id = p_related_sdp_order_id
853: where order_id = p_curr_sdp_order_id;
854:
855: update xdp_order_headers
856: set
857: last_updated_by = FND_GLOBAL.USER_ID,
858: last_update_date = sysdate,
859: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 916: update xdp_order_headers

912: sysdate,
913: FND_GLOBAL.LOGIN_ID
914: );
915:
916: update xdp_order_headers
917: set
918: last_updated_by = FND_GLOBAL.USER_ID,
919: last_update_date = sysdate,
920: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 924: update xdp_order_headers

920: last_update_login = FND_GLOBAL.LOGIN_ID,
921: next_order_id = p_related_sdp_order_id
922: where order_id = p_curr_sdp_order_id;
923:
924: update xdp_order_headers
925: set
926: last_updated_by = FND_GLOBAL.USER_ID,
927: last_update_date = sysdate,
928: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 943: update xdp_order_headers

939: ORDER_RELATIONSHIP = lv_relation
940: where order_id = p_curr_sdp_order_id AND
941: related_order_id = p_related_sdp_order_id;
942:
943: update xdp_order_headers
944: set
945: last_updated_by = FND_GLOBAL.USER_ID,
946: last_update_date = sysdate,
947: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 951: update xdp_order_headers

947: last_update_login = FND_GLOBAL.LOGIN_ID,
948: next_order_id = p_related_sdp_order_id
949: where order_id = p_curr_sdp_order_id;
950:
951: update xdp_order_headers
952: set
953: last_updated_by = FND_GLOBAL.USER_ID,
954: last_update_date = sysdate,
955: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1039: update xdp_order_headers

1035: sysdate,
1036: FND_GLOBAL.LOGIN_ID
1037: );
1038:
1039: update xdp_order_headers
1040: set
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_date = sysdate,
1043: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1047: update xdp_order_headers

1043: last_update_login = FND_GLOBAL.LOGIN_ID,
1044: previous_order_id = p_related_sdp_order_id
1045: where order_id = p_curr_sdp_order_id;
1046:
1047: update xdp_order_headers
1048: set
1049: last_updated_by = FND_GLOBAL.USER_ID,
1050: last_update_date = sysdate,
1051: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1066: update xdp_order_headers

1062: ORDER_RELATIONSHIP = lv_relation
1063: where order_id = p_curr_sdp_order_id AND
1064: related_order_id = p_related_sdp_order_id;
1065:
1066: update xdp_order_headers
1067: set
1068: last_updated_by = FND_GLOBAL.USER_ID,
1069: last_update_date = sysdate,
1070: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1074: update xdp_order_headers

1070: last_update_login = FND_GLOBAL.LOGIN_ID,
1071: previous_order_id = p_related_sdp_order_id
1072: where order_id = p_curr_sdp_order_id;
1073:
1074: update xdp_order_headers
1075: set
1076: last_updated_by = FND_GLOBAL.USER_ID,
1077: last_update_date = sysdate,
1078: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1130: update xdp_order_headers

1126: sysdate,
1127: FND_GLOBAL.LOGIN_ID
1128: );
1129:
1130: update xdp_order_headers
1131: set
1132: last_updated_by = FND_GLOBAL.USER_ID,
1133: last_update_date = sysdate,
1134: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1138: update xdp_order_headers

1134: last_update_login = FND_GLOBAL.LOGIN_ID,
1135: previous_order_id = p_related_sdp_order_id
1136: where order_id = p_curr_sdp_order_id;
1137:
1138: update xdp_order_headers
1139: set
1140: last_updated_by = FND_GLOBAL.USER_ID,
1141: last_update_date = sysdate,
1142: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1157: update xdp_order_headers

1153: ORDER_RELATIONSHIP = lv_relation
1154: where order_id = p_curr_sdp_order_id AND
1155: related_order_id = p_related_sdp_order_id;
1156:
1157: update xdp_order_headers
1158: set
1159: last_updated_by = FND_GLOBAL.USER_ID,
1160: last_update_date = sysdate,
1161: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1165: update xdp_order_headers

1161: last_update_login = FND_GLOBAL.LOGIN_ID,
1162: previous_order_id = p_related_sdp_order_id
1163: where order_id = p_curr_sdp_order_id;
1164:
1165: update xdp_order_headers
1166: set
1167: last_updated_by = FND_GLOBAL.USER_ID,
1168: last_update_date = sysdate,
1169: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1486: xdp_order_headers

1482: lv_header.order_type,
1483: lv_header.previous_order_id,
1484: lv_header.next_order_id
1485: from
1486: xdp_order_headers
1487: where
1488: order_id = p_sdp_order_id;
1489:
1490: return lv_header;

Line 1742: 'XDP_ORDER_HEADERS OHR, XDP_ORDER_LINE_ITEMS OLM '||

1738: END IF;
1739:
1740: IF lv_order_flag = TRUE and lv_line_flag = TRUE THEN
1741: lv_plsql := 'SELECT DISTINCT OHR.ORDER_ID FROM '||
1742: 'XDP_ORDER_HEADERS OHR, XDP_ORDER_LINE_ITEMS OLM '||
1743: ' WHERE OHR.ORDER_ID = OLM.ORDER_ID AND '||
1744: p_where;
1745: ELSIF lv_order_flag = TRUE and lv_line_flag = FALSE THEN
1746: lv_plsql := 'SELECT DISTINCT OHR.ORDER_ID FROM '||

Line 1747: 'XDP_ORDER_HEADERS OHR '||

1743: ' WHERE OHR.ORDER_ID = OLM.ORDER_ID AND '||
1744: p_where;
1745: ELSIF lv_order_flag = TRUE and lv_line_flag = FALSE THEN
1746: lv_plsql := 'SELECT DISTINCT OHR.ORDER_ID FROM '||
1747: 'XDP_ORDER_HEADERS OHR '||
1748: ' WHERE '||
1749: p_where;
1750:
1751: ELSIF lv_order_flag = FALSE and lv_line_flag = TRUE THEN